Web Development
PHP, AJAX, Bootstrap — full-stack web development from scratch.
₹8,000
3 Months
Microsoft Excel Mastery
Advanced Excel Course
in Howrah & Kolkata
Master Microsoft Excel from absolute basics to advanced data analysis. 25 comprehensive modules covering PivotTables, VLOOKUP, INDEX-MATCH, Charts, Macros, Date functions, and much more — taught in Bengali & Hindi with hands-on practice.
20
Total Classes
20h
Course Duration
25
Modules
10–15
Batch Size
100%
Practical
Course Details
What You Get
Everything you need to go from Excel beginner to data analysis pro — in one structured course.
20 Classes
Structured 20-hour programme with step-by-step progression. Each class builds on the previous one.
ISO & MSME Certificate
Receive an industry-recognized certificate from a government-registered, ISO-certified institution.
Small Batch Sizes
Only 10–15 students per batch to ensure personal attention and effective learning for everyone.
Bengali & Hindi Medium
Classes taught in Bengali and Hindi so complex concepts are easy to understand in your mother tongue.
Online & Offline
Flexible modes — attend our Howrah campus or join live online sessions. Same quality either way.
Beginner to Advanced
No prior knowledge required. We start from scratch and take you all the way to advanced data analysis.
Full Curriculum
Course Syllabus
25 modules covering every essential Advanced Excel skill — from basics to pro-level data mastery.
01
Excel Quick Overview (2007/2010/2013/2016)
- Difference between Excel 2003, 2007, 2010, 2013, and 2016
- Use of Excel, its boundaries & key features
02
Basic Formulas & BODMAS
- Formulae that Add / Subtract / Multiply / Divide
- BODMAS rules & Formula Error Checking
- The SUM Function — basics & shortcuts
03
Absolute & Relative Cell Referencing
- Problems with Absolute vs Relative Cell Referencing
- Creating Absolute & Mixed References using $ sign
04
LOOKUP Functions (VLOOKUP & HLOOKUP)
- The VLOOKUP Function — syntax & real-world use
- The HLOOKUP Function — horizontal data lookups
05
PivotTables — Fundamentals
- Creating & Formatting Simple PivotTables
- Using Page Field in a PivotTable
- Formatting & Styling a PivotTable
- Creating & Modifying a PivotChart
06
Logical Functions (IF, AND, OR, NOT)
- IF and Nested IF functions
- Using AND / OR / NOT Functions
07
Statistical Functions
- SUMIF & COUNTIF Functions
- AVERAGE / COUNT / LARGE / SMALL Functions
08
PivotTables — Advanced
- Adding new Calculated Fields & Items
- Changing the Summary Function
- Consolidate Pivot Table across sheets
09
LOOKUP Functions — Advanced
- MATCH with VLOOKUP combination
- INDEX & MATCH — the power combo
- OFFSET & INDIRECT functions
10
Logical Functions — Advanced
- IF Loop and Nested IF Loops
- Using IF / ISERROR function combination
11
Chart Data Techniques
- Chart Types & the Chart Wizard
- Adding Titles / Legends / Data Labels
- Printing Charts professionally
- Formatting / Renaming / Deleting Data Series
12
Date & Time Functions
- TODAY, NOW & DATE Functions
- DATEDIF / NETWORKDAYS / EOMONTH
- WEEKNUM / EDATE / NETWORKDAYS.INTL
13
Text Functions
- MID / SEARCH / LEFT / RIGHT
- TRIM / CLEAN / UPPER / LOWER
- SUBSTITUTE / TEXT Functions
- PROPER / DOLLAR Functions
14
Validations & Conditional Formatting
- Input Messages / Error Alerts / Drop-Down Lists
- Conditional Formatting rules & styles
15
Advanced Filters
- Extracting Records with Advanced Filter
- Using Formulas in Filter Criteria
16
Advanced Sorting
- Sorting Top to Bottom / Left to Right
- Creating & Deleting Custom Lists
- Sort using Custom Lists
17
Hyper/Data Linking
- Hyperlinking data within sheet / workbook
- Linking & updating links between workbooks & applications
18
Math & Trigonometry Functions
- SUMPRODUCT Function
- FLOOR / CEILING / MROUND / MOD / QUOTIENT
19
Summarizing Data & Subtotals
- Creating Subtotals & Nested Subtotals
- SUBTOTALS Formula usage
20
Outlining — Grouping & Ungrouping
- Creating Automatic & Manual Outlines
- Grouping & Ungrouping rows and columns
21
Consolidation
- Consolidating Data with Identical Layout
- Consolidating Data with Different Layout
22
Auditing Tools & Formula Tracing
- Displaying / Removing Dependent & Precedent Arrows
- Evaluate Formula — Step IN / Step Out
23
Custom Views
- Creating Custom Views
- Displaying & Switching between Custom Views
- Deleting Custom Views
24
Sharing & Protecting Workbooks
- Sharing Workbooks & Tracking Changes
- Protecting Sheets / Workbooks / Files with passwords
25
Importing & Exporting Data
- Importing Data from Database / Text Files / Web
- Exporting Data to various formats
- Changing External Data Range properties
What You'll Learn
Learning Outcomes
By the end of this course, you'll be able to handle any Excel task at a professional level.
Build Dynamic Dashboards
Create professional, interactive dashboards using PivotTables, PivotCharts, and Slicers to present data visually.
Master Lookup & Reference
Confidently use VLOOKUP, HLOOKUP, INDEX-MATCH, OFFSET, and INDIRECT to search and link data across workbooks.
Analyze Data Professionally
Apply advanced filters, sorting, subtotals, and consolidation to extract insights from large, complex datasets.
Write Complex Formulas
Combine logical, text, date, math, and statistical functions into powerful nested formulas for any business scenario.
Secure & Share Workbooks
Protect sheets and workbooks with passwords, track changes, share files safely, and manage multi-user environments.
Create Professional Charts
Design, format, and present clear, compelling charts and graphs from raw data — ready for reports and presentations.
Who Should Join?
This Course Is For You
Whether you're a student, a job seeker, or a working professional — Excel skills open new doors.
🎓
College Students
BCA, MCA, BCom, MBA students who want to add Excel to their resume and shine in campus placements and internships.
💼
Working Professionals
Accountants, managers, sales executives, HR professionals — anyone who works with data and wants to work smarter.
🎒
School & Fresh Graduates
Class XI–XII students and fresh graduates who want to build job-ready skills before entering the workforce.
FAQ
Frequently Asked Questions
What is the fee for the Advanced Excel course?
The batch class fee is ₹3,000 for the complete Advanced Excel course (20 classes, 20 hours, 25 modules). If you prefer One-to-One personalized sessions, the fee is ₹6,000 — double the batch price, with dedicated instructor attention and a fully flexible schedule.
Do I need prior Excel knowledge to join?
No prior knowledge is required at all. The course starts from the very basics — covering what Excel is, how to navigate it, and basic formulas — before progressing to advanced concepts. Complete beginners are very welcome.
Is there an online option available?
Yes! We offer both online and offline classes. Online classes are conducted live with the same instructor and the same quality of content as in-person sessions at our Howrah campus. You can choose what works best for your schedule.
What certificate will I receive?
You will receive a course completion certificate from PBA Institute, which is ISO 9001:2015 Certified and MSME Registered. This certificate adds real credibility to your resume and is recognised by employers across industries.
What is the difference between Batch and One-to-One classes?
Batch classes (₹3,000) have 10–15 students per session with fixed timing. One-to-One classes (₹6,000) are completely personalized — the schedule is set according to your availability, the pace is tailored to your learning speed, and you get undivided instructor attention throughout, plus priority doubt resolution and custom practice exercises.
Are study materials provided?
Yes. Both batch and one-to-one students receive study materials and software installation support. You'll also get practice data sheets and assessment tasks to reinforce your learning after each module.
Start Today
Ready to Master Excel?
Join PBA Institute's Advanced Excel course and build skills that employers actually want. Book your free demo class today — no commitment required.